package com.huawei.codearts.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huawei.codearts.model.WbIp;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * mybatis 需要用到的 mapper 类
 */
@Mapper
public interface WbIpMapper extends BaseMapper<WbIp> {

    @Select("select * from qhdzs_wb_ip where ip = #{ip} and type = #{type} and state = #{state} limit 0, 1")
    WbIp getIpOne(String ip, int type, int state);

}


